IMG
Loading..
Select a color
SOLID COLOR SILK TIE
Item: TD-SCS-009-058

Oppps.. This color is currently out-of stock, Please contact us for availablitiy.

QTY:
List Price:
100% silk neck tie; 58" standard length. Available in white, black, navy blue, red, maroon, royal blue, hunter green, kelly green, purple, grey, charcoal grey, gold, pink, brown, champagne beige, yellow, french blue, turquoise, lime green, vegas gold, athletic gold, teal, violet, orange and fuchsia. Complimenting scarf available. Screen printing, laser etching, laser sheen and pad printing available - 3" x 3" maximum imprint area. Price shown is for the blank item only and does not include decoration.
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`, MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`, `I`.`AltShowListID`, `I`.`InventoryOnly` FROM `tbl_items` `I` LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076') WHERE (`I`.`ItemGroup` = 'TD-SCS-009-058') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') GROUP BY `I`.`ListID` ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`